Import of customer data (text format)
Warning: The
following list describes the customer information which can/must be written
into the import file. You must follow the conventions and instructions in the
following section so that the import can take place error free. At the end of
the section there is a list with instructions for the recovery of errors with
the import.
For each customer the following information can be set in the import file (Position Description of the field):
- Key designator for the
network (max. 40 characters).
- An import filter can be defined for the import function using this. Only the customers whose key designator agrees with the network name are imported (see Network)!
- Unique Customer designator (max. 40 characters).
- Assigned and existing Node "no compression" with max. 19 characters.
- Assigned and existing Node for "low compression" with max. 19 characters.
- Assigned and existing Node for "high compression" with max. 19 characters.
- Designator of the existing Consumer group (max. 40 characters).
- Designator of the existing Organization group (max. 40 characters).
- Nominal heat output in [W].
- Nominal decrease mass flow [kg/s].
- Amount of heat taken in the current year [Ws].
- Amount of heat taken last year [Ws].
- Quantity of water taken in the current year [kg].
- Quantity of water taken last year [kg].
- Floor space [m2].
- Bypass diameter [m].
- 1. barrier list1, ignored – formerly LICHEAT.
- 2. barrier list2, ignored – formerly LICHEAT.
- House name (max. 20 characters).
- First name (max. 20 characters).
- Road (max. 20 characters).
- House number (max. 8 characters).
- City/town (max. 20 characters).
- Postal/zip code (max. 8 characters).
- Private telephone number (max. 14 characters).
- Work telephone number (max. 14 characters).
- Heat accumulator available (J/N).
- Instantaneous water heater available (J/N).
- Heat exchanger available (J/N).
- Alternative available (J/N).
- Volumes taken in the current year [m3].
- Volume taken in previous year [m3].
- Flow rate [m3].
The customer file must meet the following conditions:
- all data of a customer must have been entered in one line
- the individual input fields are to be separated by a comma
- only the information 1 to 9 is absolutely necessarily; all further details are optional
- designators which contain special characters such as commas or blanks must be surrounded by quotation marks (")
- designators, in which a comma follows a quotation mark, which contain quotation marks themselves, which have initial or final spaces or tab marks are not permitted